Profiling Report

Dataset statistics

Number of variables	13
Number of observations	28080
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.8 MiB
Average record size in memory	104.0 B

Variable types

Numeric	7
Categorical	4
Text	2

Alerts

`periodo` is uniformly distributed	Uniform
`plan_precios_cuidados` has 27842 (99.2%) zeros	Zeros
`cust_request_qty` has 5731 (20.4%) zeros	Zeros
`cust_request_tn` has 5731 (20.4%) zeros	Zeros
`tn` has 5731 (20.4%) zeros	Zeros

Reproduction

Analysis started	2024-07-13 12:45:13.949006
Analysis finished	2024-07-13 12:45:19.652266
Duration	5.7 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

product_id
Real number (ℝ)

Distinct	780
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20541.422

Minimum	20001
Maximum	21276
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	219.5 KiB

Quantile statistics

Minimum	20001
5-th percentile	20042.95
Q1	20238.75
median	20511.5
Q3	20818.5
95-th percentile	21167.05
Maximum	21276
Range	1275
Interquartile range (IQR)	579.75

Descriptive statistics

Standard deviation	353.76366
Coefficient of variation (CV)	0.017221965
Kurtosis	-1.0230288
Mean	20541.422
Median Absolute Deviation (MAD)	286
Skewness	0.29765975
Sum	5.7680312 × 10⁸
Variance	125148.72
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20001	36	0.1%
20202	36	0.1%
20343	36	0.1%
20377	36	0.1%
20417	36	0.1%
20750	36	0.1%
20832	36	0.1%
20855	36	0.1%
20877	36	0.1%
20914	36	0.1%
Other values (770)	27720	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20001	36	0.1%
20002	36	0.1%
20003	36	0.1%
20004	36	0.1%
20005	36	0.1%
20006	36	0.1%
20007	36	0.1%
20008	36	0.1%
20009	36	0.1%
20010	36	0.1%

Value	Count	Frequency (%)
21276	36	0.1%
21267	36	0.1%
21266	36	0.1%
21265	36	0.1%
21263	36	0.1%
21262	36	0.1%
21259	36	0.1%
21256	36	0.1%
21252	36	0.1%
21248	36	0.1%

periodo
Categorical

UNIFORM

Distinct	36
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	219.5 KiB

2017-01-01	780
2017-02-01	780
2017-09-01	780
2017-03-01	780
2017-04-01	780
Other values (31)	24180

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	280800
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017-01-01
2nd row	2017-02-01
3rd row	2017-03-01
4th row	2017-04-01
5th row	2017-05-01

Common Values

Value	Count	Frequency (%)
2017-01-01	780	2.8%
2017-02-01	780	2.8%
2017-09-01	780	2.8%
2017-03-01	780	2.8%
2017-04-01	780	2.8%
2017-05-01	780	2.8%
2017-06-01	780	2.8%
2017-07-01	780	2.8%
2017-08-01	780	2.8%
2017-10-01	780	2.8%
Other values (26)	20280	72.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-01-01	780	2.8%
2017-02-01	780	2.8%
2019-03-01	780	2.8%
2018-09-01	780	2.8%
2018-10-01	780	2.8%
2018-11-01	780	2.8%
2018-12-01	780	2.8%
2019-01-01	780	2.8%
2019-02-01	780	2.8%
2019-04-01	780	2.8%
Other values (26)	20280	72.2%

Most occurring characters

Value	Count	Frequency (%)
0	79560	28.3%
1	67860	24.2%
-	56160	20.0%
2	32760	11.7%
7	11700	4.2%
9	11700	4.2%
8	11700	4.2%
3	2340	0.8%
4	2340	0.8%
5	2340	0.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	280800	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	79560	28.3%
1	67860	24.2%
-	56160	20.0%
2	32760	11.7%
7	11700	4.2%
9	11700	4.2%
8	11700	4.2%
3	2340	0.8%
4	2340	0.8%
5	2340	0.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	280800	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	79560	28.3%
1	67860	24.2%
-	56160	20.0%
2	32760	11.7%
7	11700	4.2%
9	11700	4.2%
8	11700	4.2%
3	2340	0.8%
4	2340	0.8%
5	2340	0.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	280800	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	79560	28.3%
1	67860	24.2%
-	56160	20.0%
2	32760	11.7%
7	11700	4.2%
9	11700	4.2%
8	11700	4.2%
3	2340	0.8%
4	2340	0.8%
5	2340	0.8%

plan_precios_cuidados
Real number (ℝ)

ZEROS

Distinct	135
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.99465812

Minimum	0
Maximum	289
Zeros	27842
Zeros (%)	99.2%
Negative	0
Negative (%)	0.0%
Memory size	219.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	289
Range	289
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	11.59233
Coefficient of variation (CV)	11.654587
Kurtosis	180.31647
Mean	0.99465812
Median Absolute Deviation (MAD)	0
Skewness	12.908125
Sum	27930
Variance	134.38211
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	27842	99.2%
93	6	< 0.1%
159	5	< 0.1%
87	5	< 0.1%
110	4	< 0.1%
65	4	< 0.1%
129	4	< 0.1%
63	4	< 0.1%
144	4	< 0.1%
123	4	< 0.1%
Other values (125)	198	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	27842	99.2%
9	1	< 0.1%
22	1	< 0.1%
25	1	< 0.1%
29	1	< 0.1%
30	1	< 0.1%
32	2	< 0.1%
37	1	< 0.1%
42	1	< 0.1%
44	2	< 0.1%

Value	Count	Frequency (%)
289	1	< 0.1%
274	1	< 0.1%
218	1	< 0.1%
217	1	< 0.1%
213	1	< 0.1%
207	1	< 0.1%
205	1	< 0.1%
200	1	< 0.1%
199	1	< 0.1%
192	1	< 0.1%

cust_request_qty
Real number (ℝ)

ZEROS

Distinct	652
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	177.30345

Minimum	0
Maximum	756
Zeros	5731
Zeros (%)	20.4%
Negative	0
Negative (%)	0.0%
Memory size	219.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	50
median	167
Q3	275
95-th percentile	433
Maximum	756
Range	756
Interquartile range (IQR)	225

Descriptive statistics

Standard deviation	142.31954
Coefficient of variation (CV)	0.80268906
Kurtosis	-0.42606118
Mean	177.30345
Median Absolute Deviation (MAD)	112
Skewness	0.49717329
Sum	4978681
Variance	20254.852
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5731	20.4%
151	99	0.4%
126	91	0.3%
210	91	0.3%
168	89	0.3%
184	88	0.3%
147	88	0.3%
124	88	0.3%
208	87	0.3%
140	87	0.3%
Other values (642)	21541	76.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5731	20.4%
1	25	0.1%
2	19	0.1%
3	16	0.1%
4	20	0.1%
5	42	0.1%
6	26	0.1%
7	33	0.1%
8	25	0.1%
9	20	0.1%

Value	Count	Frequency (%)
756	1	< 0.1%
736	1	< 0.1%
725	1	< 0.1%
721	1	< 0.1%
718	1	< 0.1%
704	1	< 0.1%
701	1	< 0.1%
696	2	< 0.1%
695	1	< 0.1%
691	1	< 0.1%

cust_request_tn
Real number (ℝ)

ZEROS

Distinct	22141
Distinct (%)	78.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.880852

Minimum	0
Maximum	2423.7088
Zeros	5731
Zeros (%)	20.4%
Negative	0
Negative (%)	0.0%
Memory size	219.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.459455
median	6.22387
Q3	25.083377
95-th percentile	190.09327
Maximum	2423.7088
Range	2423.7088
Interquartile range (IQR)	24.623922

Descriptive statistics

Standard deviation	117.3055
Coefficient of variation (CV)	2.8694486
Kurtosis	67.527369
Mean	40.880852
Median Absolute Deviation (MAD)	6.22387
Skewness	6.8592699
Sum	1147934.3
Variance	13760.581
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5731	20.4%
0.00988	5	< 0.1%
0.00874	4	< 0.1%
0.0127	3	< 0.1%
6.3063	3	< 0.1%
66.41271	3	< 0.1%
0.48948	3	< 0.1%
1.51788	3	< 0.1%
0.01128	3	< 0.1%
0.02682	3	< 0.1%
Other values (22131)	22319	79.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5731	20.4%
0.00089	1	< 0.1%
0.00092	1	< 0.1%
0.00218	1	< 0.1%
0.00223	1	< 0.1%
0.00268	1	< 0.1%
0.00294	1	< 0.1%
0.00295	1	< 0.1%
0.00301	1	< 0.1%
0.00311	1	< 0.1%

Value	Count	Frequency (%)
2423.70881	1	< 0.1%
2013.36305	1	< 0.1%
2010.29987	1	< 0.1%
1945.84961	1	< 0.1%
1902.79056	1	< 0.1%
1859.88471	1	< 0.1%
1823.35962	1	< 0.1%
1782.81423	1	< 0.1%
1757.73271	1	< 0.1%
1734.24194	1	< 0.1%

tn
Real number (ℝ)

ZEROS

Distinct	22146
Distinct (%)	78.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	39.978818

Minimum	0
Maximum	2295.1983
Zeros	5731
Zeros (%)	20.4%
Negative	0
Negative (%)	0.0%
Memory size	219.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.459985
median	6.1997
Q3	24.879885
95-th percentile	186.68862
Maximum	2295.1983
Range	2295.1983
Interquartile range (IQR)	24.4199

Descriptive statistics

Standard deviation	113.35357
Coefficient of variation (CV)	2.8353406
Kurtosis	65.75445
Mean	39.978818
Median Absolute Deviation (MAD)	6.1997
Skewness	6.7677241
Sum	1122605.2
Variance	12849.031
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5731	20.4%
0.00988	5	< 0.1%
0.00874	4	< 0.1%
0.0127	3	< 0.1%
0.01128	3	< 0.1%
0.02682	3	< 0.1%
1.51788	3	< 0.1%
0.48948	3	< 0.1%
2.02891	3	< 0.1%
6.3063	3	< 0.1%
Other values (22136)	22319	79.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5731	20.4%
0.00089	1	< 0.1%
0.00092	1	< 0.1%
0.00218	1	< 0.1%
0.00223	1	< 0.1%
0.00268	1	< 0.1%
0.00294	1	< 0.1%
0.00295	1	< 0.1%
0.00301	1	< 0.1%
0.00311	1	< 0.1%

Value	Count	Frequency (%)
2295.19832	1	< 0.1%
1979.53635	1	< 0.1%
1958.59845	1	< 0.1%
1856.83534	1	< 0.1%
1813.01511	1	< 0.1%
1800.96168	1	< 0.1%
1766.81068	1	< 0.1%
1678.99318	1	< 0.1%
1660.00561	1	< 0.1%
1647.63848	1	< 0.1%

cant_periodos
Real number (ℝ)

Distinct	29
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.652564

Minimum	4
Maximum	36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	219.5 KiB

Quantile statistics

Minimum	4
5-th percentile	6
Q1	21
median	36
Q3	36
95-th percentile	36
Maximum	36
Range	32
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.038524
Coefficient of variation (CV)	0.38525432
Kurtosis	-0.43680349
Mean	28.652564
Median Absolute Deviation (MAD)	0
Skewness	-1.1107161
Sum	804564
Variance	121.84901
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
36	17208	61.3%
9	1080	3.8%
6	792	2.8%
15	684	2.4%
16	684	2.4%
35	612	2.2%
7	576	2.1%
5	540	1.9%
10	540	1.9%
26	540	1.9%
Other values (19)	4824	17.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	324	1.2%
5	540	1.9%
6	792	2.8%
7	576	2.1%
8	468	1.7%
9	1080	3.8%
10	540	1.9%
11	144	0.5%
14	360	1.3%
15	684	2.4%

Value	Count	Frequency (%)
36	17208	61.3%
35	612	2.2%
34	180	0.6%
33	72	0.3%
32	144	0.5%
31	252	0.9%
30	432	1.5%
29	180	0.6%
28	216	0.8%
27	468	1.7%

cat1
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	219.5 KiB

PC	15984
HC	6732
FOODS	5148
REF	216

Length

Max length	5
Median length	2
Mean length	2.5576923
Min length	2

Characters and Unicode

Total characters	71820
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HC
2nd row	HC
3rd row	HC
4th row	HC
5th row	HC

Common Values

Value	Count	Frequency (%)
PC	15984	56.9%
HC	6732	24.0%
FOODS	5148	18.3%
REF	216	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pc	15984	56.9%
hc	6732	24.0%
foods	5148	18.3%
ref	216	0.8%

Most occurring characters

Value	Count	Frequency (%)
C	22716	31.6%
P	15984	22.3%
O	10296	14.3%
H	6732	9.4%
F	5364	7.5%
D	5148	7.2%
S	5148	7.2%
R	216	0.3%
E	216	0.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	71820	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	22716	31.6%
P	15984	22.3%
O	10296	14.3%
H	6732	9.4%
F	5364	7.5%
D	5148	7.2%
S	5148	7.2%
R	216	0.3%
E	216	0.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	71820	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	22716	31.6%
P	15984	22.3%
O	10296	14.3%
H	6732	9.4%
F	5364	7.5%
D	5148	7.2%
S	5148	7.2%
R	216	0.3%
E	216	0.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	71820	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	22716	31.6%
P	15984	22.3%
O	10296	14.3%
H	6732	9.4%
F	5364	7.5%
D	5148	7.2%
S	5148	7.2%
R	216	0.3%
E	216	0.3%

cat2
Categorical

Distinct	15
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	219.5 KiB

CABELLO	7308
DEOS	4428
SOPAS Y CALDOS	3060
HOGAR	2268
PIEL2	2052
Other values (10)	8964

Length

Max length	19
Median length	14
Mean length	7.5294872
Min length	2

Characters and Unicode

Total characters	211428
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ROPA LAVADO
2nd row	ROPA LAVADO
3rd row	ROPA LAVADO
4th row	ROPA LAVADO
5th row	ROPA LAVADO

Common Values

Value	Count	Frequency (%)
CABELLO	7308	26.0%
DEOS	4428	15.8%
SOPAS Y CALDOS	3060	10.9%
HOGAR	2268	8.1%
PIEL2	2052	7.3%
ROPA LAVADO	1908	6.8%
ADEREZOS	1764	6.3%
PIEL1	1692	6.0%
VAJILLA	1188	4.2%
ROPA ACONDICIONADOR	756	2.7%
Other values (5)	1656	5.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
cabello	7308	19.8%
deos	4428	12.0%
sopas	3060	8.3%
y	3060	8.3%
caldos	3060	8.3%
ropa	2736	7.4%
hogar	2268	6.1%
piel2	2052	5.6%
lavado	1908	5.2%
aderezos	1764	4.8%
Other values (8)	5292	14.3%

Most occurring characters

Value	Count	Frequency (%)
O	30528	14.4%
A	29088	13.8%
L	26748	12.7%
E	20268	9.6%
S	16308	7.7%
D	13176	6.2%
C	11952	5.7%
P	10080	4.8%
	8856	4.2%
R	8388	4.0%
Other values (14)	36036	17.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	211428	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
O	30528	14.4%
A	29088	13.8%
L	26748	12.7%
E	20268	9.6%
S	16308	7.7%
D	13176	6.2%
C	11952	5.7%
P	10080	4.8%
	8856	4.2%
R	8388	4.0%
Other values (14)	36036	17.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	211428	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
O	30528	14.4%
A	29088	13.8%
L	26748	12.7%
E	20268	9.6%
S	16308	7.7%
D	13176	6.2%
C	11952	5.7%
P	10080	4.8%
	8856	4.2%
R	8388	4.0%
Other values (14)	36036	17.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	211428	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
O	30528	14.4%
A	29088	13.8%
L	26748	12.7%
E	20268	9.6%
S	16308	7.7%
D	13176	6.2%
C	11952	5.7%
P	10080	4.8%
	8856	4.2%
R	8388	4.0%
Other values (14)	36036	17.0%

cat3
Text

Distinct	84
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	219.5 KiB

Length

Max length	19
Median length	16
Mean length	7.9589744
Min length	3

Characters and Unicode

Total characters	223488
Distinct characters	51
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Liquido
2nd row	Liquido
3rd row	Liquido
4th row	Liquido
5th row	Liquido

Value	Count	Frequency (%)
shampoo	3276	9.9%
aero	2808	8.5%
acondicionador	2772	8.4%
jabon	1368	4.1%
liquido	1224	3.7%
sopas	1152	3.5%
mayonesa	936	2.8%
polvo	900	2.7%
noaero	828	2.5%
gel	792	2.4%
Other values (80)	17028	51.5%

Most occurring characters

Value	Count	Frequency (%)
o	19260	8.6%
O	16920	7.6%
a	15948	7.1%
A	15624	7.0%
e	11340	5.1%
C	10152	4.5%
r	9936	4.4%
S	7596	3.4%
i	7488	3.4%
I	7452	3.3%
Other values (41)	101772	45.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	223488	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	19260	8.6%
O	16920	7.6%
a	15948	7.1%
A	15624	7.0%
e	11340	5.1%
C	10152	4.5%
r	9936	4.4%
S	7596	3.4%
i	7488	3.4%
I	7452	3.3%
Other values (41)	101772	45.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	223488	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	19260	8.6%
O	16920	7.6%
a	15948	7.1%
A	15624	7.0%
e	11340	5.1%
C	10152	4.5%
r	9936	4.4%
S	7596	3.4%
i	7488	3.4%
I	7452	3.3%
Other values (41)	101772	45.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	223488	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	19260	8.6%
O	16920	7.6%
a	15948	7.1%
A	15624	7.0%
e	11340	5.1%
C	10152	4.5%
r	9936	4.4%
S	7596	3.4%
i	7488	3.4%
I	7452	3.3%
Other values (41)	101772	45.5%

brand
Categorical

Distinct	35
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	219.5 KiB

NIVEA	3924
SHAMPOO3	2952
MAGGI	2808
DEOS1	2808
MUSCULO	2340
Other values (30)	13248

Length

Max length	9
Median length	8
Mean length	6.3038462
Min length	3

Characters and Unicode

Total characters	177012
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ARIEL
2nd row	ARIEL
3rd row	ARIEL
4th row	ARIEL
5th row	ARIEL

Common Values

Value	Count	Frequency (%)
NIVEA	3924	14.0%
SHAMPOO3	2952	10.5%
MAGGI	2808	10.0%
DEOS1	2808	10.0%
MUSCULO	2340	8.3%
LIMPIEX	1620	5.8%
LANCOME	1080	3.8%
SHAMPOO2	1044	3.7%
NATURA	1008	3.6%
SHAMPOO1	972	3.5%
Other values (25)	7524	26.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nivea	3924	14.0%
shampoo3	2952	10.5%
maggi	2808	10.0%
deos1	2808	10.0%
musculo	2340	8.3%
limpiex	1620	5.8%
lancome	1080	3.8%
shampoo2	1044	3.7%
natura	1008	3.6%
shampoo1	972	3.5%
Other values (25)	7524	26.8%

Most occurring characters

Value	Count	Frequency (%)
O	20268	11.5%
A	20124	11.4%
M	14184	8.0%
I	13896	7.9%
E	13608	7.7%
S	12672	7.2%
N	8244	4.7%
P	7884	4.5%
L	7524	4.3%
G	6804	3.8%
Other values (25)	51804	29.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	177012	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
O	20268	11.5%
A	20124	11.4%
M	14184	8.0%
I	13896	7.9%
E	13608	7.7%
S	12672	7.2%
N	8244	4.7%
P	7884	4.5%
L	7524	4.3%
G	6804	3.8%
Other values (25)	51804	29.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	177012	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
O	20268	11.5%
A	20124	11.4%
M	14184	8.0%
I	13896	7.9%
E	13608	7.7%
S	12672	7.2%
N	8244	4.7%
P	7884	4.5%
L	7524	4.3%
G	6804	3.8%
Other values (25)	51804	29.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	177012	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
O	20268	11.5%
A	20124	11.4%
M	14184	8.0%
I	13896	7.9%
E	13608	7.7%
S	12672	7.2%
N	8244	4.7%
P	7884	4.5%
L	7524	4.3%
G	6804	3.8%
Other values (25)	51804	29.3%

sku_size
Real number (ℝ)

Distinct	67
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	461.47051

Minimum	1
Maximum	10000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	219.5 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	90
median	220
Q3	450
95-th percentile	1012.5
Maximum	10000
Range	9999
Interquartile range (IQR)	360

Descriptive statistics

Standard deviation	900.09515
Coefficient of variation (CV)	1.9504933
Kurtosis	40.441557
Mean	461.47051
Median Absolute Deviation (MAD)	170
Skewness	5.5003224
Sum	12958092
Variance	810171.27
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	2160	7.7%
400	1944	6.9%
50	1728	6.2%
90	1656	5.9%
350	1260	4.5%
10	1152	4.1%
750	1116	4.0%
500	1008	3.6%
100	1008	3.6%
250	900	3.2%
Other values (57)	14148	50.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	288	1.0%
2	288	1.0%
3	36	0.1%
4	288	1.0%
5	540	1.9%
6	144	0.5%
8	216	0.8%
10	1152	4.1%
12	252	0.9%
15	252	0.9%

Value	Count	Frequency (%)
10000	72	0.3%
5000	396	1.4%
4000	36	0.1%
3000	720	2.6%
2000	72	0.3%
1400	72	0.3%
1250	36	0.1%
1000	468	1.7%
950	108	0.4%
930	504	1.8%

descripcion
Text

Distinct	427
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	219.5 KiB

Length

Max length	36
Median length	27
Mean length	11.774359
Min length	2

Characters and Unicode

Total characters	330624
Distinct characters	67
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	genoma
2nd row	genoma
3rd row	genoma
4th row	genoma
5th row	genoma

Value	Count	Frequency (%)
sabor	3384	6.3%
1	1476	2.7%
sopa	1080	2.0%
2	1044	1.9%
3	864	1.6%
aroma	864	1.6%
antibacterial	792	1.5%
crema	792	1.5%
maquina	720	1.3%
regular	720	1.3%
Other values (362)	42084	78.2%

Most occurring characters

Value	Count	Frequency (%)
a	39420	11.9%
o	27720	8.4%
	25776	7.8%
i	24840	7.5%
e	21816	6.6%
r	20844	6.3%
n	19044	5.8%
l	15480	4.7%
t	13500	4.1%
s	12924	3.9%
Other values (57)	109260	33.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	330624	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	39420	11.9%
o	27720	8.4%
	25776	7.8%
i	24840	7.5%
e	21816	6.6%
r	20844	6.3%
n	19044	5.8%
l	15480	4.7%
t	13500	4.1%
s	12924	3.9%
Other values (57)	109260	33.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	330624	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	39420	11.9%
o	27720	8.4%
	25776	7.8%
i	24840	7.5%
e	21816	6.6%
r	20844	6.3%
n	19044	5.8%
l	15480	4.7%
t	13500	4.1%
s	12924	3.9%
Other values (57)	109260	33.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	330624	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	39420	11.9%
o	27720	8.4%
	25776	7.8%
i	24840	7.5%
e	21816	6.6%
r	20844	6.3%
n	19044	5.8%
l	15480	4.7%
t	13500	4.1%
s	12924	3.9%
Other values (57)	109260	33.0%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	product_id	periodo	cust_request_qty	cust_request_tn	tn	cant_periodos	cat1	cat2	cat3	brand	sku_size	descripcion
0	20001	2017-01-01	479.0	937.72717	934.77222	36	HC	ROPA LAVADO	Liquido	ARIEL	3000	genoma
1	20001	2017-02-01	432.0	833.72187	798.01620	36	HC	ROPA LAVADO	Liquido	ARIEL	3000	genoma
2	20001	2017-03-01	509.0	1330.74697	1303.35771	36	HC	ROPA LAVADO	Liquido	ARIEL	3000	genoma
3	20001	2017-04-01	279.0	1132.94430	1069.96130	36	HC	ROPA LAVADO	Liquido	ARIEL	3000	genoma
4	20001	2017-05-01	701.0	1550.68936	1502.20132	36	HC	ROPA LAVADO	Liquido	ARIEL	3000	genoma
5	20001	2017-06-01	570.0	1575.82891	1520.06539	36	HC	ROPA LAVADO	Liquido	ARIEL	3000	genoma
6	20001	2017-07-01	381.0	1086.47101	1030.67391	36	HC	ROPA LAVADO	Liquido	ARIEL	3000	genoma
7	20001	2017-08-01	643.0	1289.66869	1267.39462	36	HC	ROPA LAVADO	Liquido	ARIEL	3000	genoma
8	20001	2017-09-01	381.0	1356.96103	1316.94604	36	HC	ROPA LAVADO	Liquido	ARIEL	3000	genoma
9	20001	2017-10-01	273.0	1441.60247	1439.75563	36	HC	ROPA LAVADO	Liquido	ARIEL	3000	genoma

	product_id	periodo	cust_request_qty	cust_request_tn	tn	cant_periodos	cat1	cat2	cat3	brand	sku_size	descripcion
28070	21214	2019-03-01	0.0	0.00000	0.00000	4	PC	DEOS	RollOn	NIVEA	50	Aroma 14
28071	21214	2019-04-01	0.0	0.00000	0.00000	4	PC	DEOS	RollOn	NIVEA	50	Aroma 14
28072	21214	2019-05-01	0.0	0.00000	0.00000	4	PC	DEOS	RollOn	NIVEA	50	Aroma 14
28073	21214	2019-06-01	0.0	0.00000	0.00000	4	PC	DEOS	RollOn	NIVEA	50	Aroma 14
28074	21214	2019-07-01	0.0	0.00000	0.00000	4	PC	DEOS	RollOn	NIVEA	50	Aroma 14
28075	21214	2019-08-01	0.0	0.00000	0.00000	4	PC	DEOS	RollOn	NIVEA	50	Aroma 14
28076	21214	2019-09-01	3.0	0.34250	0.34250	4	PC	DEOS	RollOn	NIVEA	50	Aroma 14
28077	21214	2019-10-01	46.0	0.21735	0.21735	4	PC	DEOS	RollOn	NIVEA	50	Aroma 14
28078	21214	2019-11-01	88.0	0.84012	0.84012	4	PC	DEOS	RollOn	NIVEA	50	Aroma 14
28079	21214	2019-12-01	55.0	0.24428	0.24428	4	PC	DEOS	RollOn	NIVEA	50	Aroma 14

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Missing values

Sample